from django.db import models

class PublishedSeismicDatabase(models.Model):
    number = models.AutoField(primary_key=True)
    id = models.CharField(db_column='ID', max_length=36, blank=True, null=True)  # Field name made lowercase.
    eqttime = models.CharField(db_column='EQTTIME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    longitude = models.CharField(db_column='LONGITUDE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    latitude = models.CharField(db_column='LATITUDE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    magnitude = models.CharField(db_column='MAGNITUDE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    depth = models.CharField(db_column='DEPTH', max_length=255, blank=True, null=True)  # Field name made lowercase.
    intensity = models.FloatField(db_column='Intensity', blank=True, null=True)  # Field name made lowercase.
    eqtrange = models.CharField(db_column='EQTRANGE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    objectid = models.IntegerField(db_column='OBJECTID', blank=True, null=True)  # Field name made lowercase.
    x_longitude = models.CharField(max_length=255, blank=True, null=True)
    x_latitude = models.CharField(max_length=255, blank=True, null=True)
    gb_code = models.CharField(db_column='GB_CODE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    eqtname = models.CharField(max_length=255, blank=True, null=True)
    abbreviation = models.CharField(max_length=255, blank=True, null=True)
    city = models.CharField(max_length=255, blank=True, null=True)
    province = models.CharField(max_length=255, blank=True, null=True)
    tel = models.CharField(max_length=255, blank=True, null=True)
    remark = models.CharField(max_length=1000, blank=True, null=True)
    abvprovince = models.CharField(db_column='abvProvince', max_length=255, blank=True, null=True)  # Field name made lowercase.
    fullname = models.CharField(db_column='fullName', max_length=255, blank=True, null=True)  # Field name made lowercase.
    abbreviationthree = models.CharField(db_column='abbreviationThree', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pop_all = models.CharField(db_column='POP_ALL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pop_countryside = models.CharField(db_column='POP_COUNTRYSIDE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pop_town = models.CharField(db_column='POP_TOWN', max_length=255, blank=True, null=True)  # Field name made lowercase.
    gdp = models.CharField(db_column='GDP', max_length=255, blank=True, null=True)  # Field name made lowercase.
    fst_industry = models.CharField(db_column='FST_INDUSTRY', max_length=255, blank=True, null=True)  # Field name made lowercase.
    snd_industry = models.CharField(db_column='SND_INDUSTRY', max_length=255, blank=True, null=True)  # Field name made lowercase.
    trd_industry = models.CharField(db_column='TRD_INDUSTRY', max_length=255, blank=True, null=True)  # Field name made lowercase.
    townnum = models.CharField(db_column='townNum', max_length=255, blank=True, null=True)  # Field name made lowercase.
    villagenum = models.CharField(db_column='villageNum', max_length=255, blank=True, null=True)  # Field name made lowercase.
    climate = models.TextField(blank=True, null=True)
    area = models.CharField(max_length=255, blank=True, null=True)
    altitudel = models.CharField(db_column='altitudeL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    altitudelname = models.CharField(db_column='altitudeLName', max_length=255, blank=True, null=True)  # Field name made lowercase.
    altitudeh = models.CharField(db_column='altitudeH', max_length=255, blank=True, null=True)  # Field name made lowercase.
    altitudehname = models.CharField(db_column='altitudeHName', max_length=255, blank=True, null=True)  # Field name made lowercase.
    altitudeaverage = models.CharField(db_column='altitudeAverage', max_length=255, blank=True, null=True)  # Field name made lowercase.
    topographic = models.TextField(blank=True, null=True)
    villageaverincom = models.CharField(db_column='villageAverIncom', max_length=255, blank=True, null=True)  # Field name made lowercase.
    urbanaverincome = models.CharField(db_column='urbanAverIncome', max_length=255, blank=True, null=True)  # Field name made lowercase.
    population = models.TextField(db_column='Population', blank=True, null=True)  # Field name made lowercase.
    economics = models.TextField(db_column='Economics', blank=True, null=True)  # Field name made lowercase.
    altitudecenter = models.CharField(db_column='altitudeCenter', max_length=11, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'published_seismic_database'